<?


	// Comments Table
	define("SPEC_TBL_COMMENTS", 				"ffxivc_comments");
	define("SPEC_TBL_COMMENTS_ID", 				"commentId");
	define("SPEC_TBL_COMMENTS_USER_ID", 		"userId");
	define("SPEC_TBL_COMMENTS_SPEC_ID", 		"specId");
	define("SPEC_TBL_COMMENTS_COMMENT", 		"comment");
	define("SPEC_TBL_COMMENTS_CDATE", 			"cdate");
	define("SPEC_TBL_COMMENTS_UDATE", 			"udate");

	// Jobs Table
	define("SPEC_TBL_JOBS", 					"ffxivc_jobs");
	define("SPEC_TBL_JOBS_ID", 					"jobId");
	define("SPEC_TBL_JOBS_TRI", 				"tri");
	define("SPEC_TBL_JOBS_NAME", 				"name");
	define("SPEC_TBL_JOBS_TYPE", 				"type");	
	
	// Ratings Table
	define("SPEC_TBL_RATINGS", 					"ffxivc_ratings");
	define("SPEC_TBL_RATINGS_ID", 				"rateId");
	define("SPEC_TBL_RATINGS_USER_ID", 			"userId");
	define("SPEC_TBL_RATINGS_SPEC_ID", 			"specId");
	define("SPEC_TBL_RATINGS_VALUE", 			"value");
	define("SPEC_TBL_RATINGS_CDATE", 			"cdate");
	define("SPEC_TBL_RATINGS_UDATE", 			"udate");
	
	
	// Specs Specs
	define("SPEC_TBL_SPECS", 					"ffxivc_specs");
	define("SPEC_TBL_SPECS_ID", 				"specId");
	define("SPEC_TBL_SPECS_USER_ID", 			"userId");
	define("SPEC_TBL_SPECS_LAYOUT", 			"layout");
	define("SPEC_TBL_SPECS_JOB_ID", 			"jobId");
	define("SPEC_TBL_SPECS_LEVEL", 				"level");
	define("SPEC_TBL_SPECS_DESCRIPTION", 		"description");
	define("SPEC_TBL_SPECS_PUBLIC", 			"public");
	define("SPEC_TBL_SPECS_CDATE", 				"cdate");
	define("SPEC_TBL_SPECS_UDATE", 				"udate");
	define("SPEC_TBL_SPECS_IMPORT", 			"import");
	
	
	// Spec components
	define("SPEC_TBL_COMPONENTS", 				"spec_components");
	define("SPEC_TBL_COMPONENTS_ID", 			"componentId");
	define("SPEC_TBL_COMPONENTS_SPEC_ID", 		"specId");
	define("SPEC_TBL_COMPONENTS_SKILL_ID", 		"skillId");
	define("SPEC_TBL_COMPONENTS_POSITION", 		"position");
	define("SPEC_TBL_COMPONENTS_TEMPLATE", 		"template");
	
	// Spec template
	define("SPEC_TBL_TEMPLATES", 				"spec_templates");
	define("SPEC_TBL_TEMPLATES_ID", 			"templateId");
	define("SPEC_TBL_TEMPLATES_JOB_ID", 		"jobId");
	define("SPEC_TBL_TEMPLATES_SKILL_ID", 		"skillId");
	
	// Spec levels
	define("SPEC_TBL_LEVELS", 					"spec_levels");
	define("SPEC_TBL_LEVELS_ID", 				"levelId");
	define("SPEC_TBL_LEVELS_JOB_ID", 			"jobId");
	define("SPEC_TBL_LEVELS_SPEC_ID", 			"specId");
	define("SPEC_TBL_LEVELS_LEVEL", 			"level");
	
		// Specs Specs
	define("SPEC_TBL_SPEC", 					"spec_specs");
	define("SPEC_TBL_SPEC_ID", 				    "specId");
	define("SPEC_TBL_SPEC_USER_ID", 			"userId");
	define("SPEC_TBL_SPEC_JOB_ID", 			    "jobId");
	define("SPEC_TBL_SPEC_LEVEL", 				"level");
	define("SPEC_TBL_SPEC_DESCRIPTION", 		"description");
	define("SPEC_TBL_SPEC_PUBLIC", 			    "public");
	define("SPEC_TBL_SPEC_CDATE", 				"cdate");
	define("SPEC_TBL_SPEC_UDATE", 				"udate");
	
?>